1- Ctrl + C on the By Crossing Border visual
2-
Ctrl + V three times
3- Drag and drop them in the spaces adjacent to each other on the canvas.
Step 1: Group and Replacing Values for By Crossing Method
1-
Enter Crossing Method in the shared axis from
Border Crossing table.
2-
Enter Border into the Column Series from the
Border Crossing table.
3-
Enter Crossing PM in the Column Values from Key
Measures table.
4-
Enter MoM% and YoY% into the Line Values from
Key Measures table.
5-
Enter MoM% and YoY% into the Tooltips.
6- Title On and change the title to By Crossing Method
1-
Enter Region & State in the shared axis from
Border Crossing table.
2-
Enter Border into the Column Series from the
Border Crossing table.
3-
Enter Crossing PM in the Column Values from Key
Measures table.
4-
Enter MoM% and YoY% into the Line Values from
Key Measures table.
5-
Enter MoM% and YoY% into the Tooltips.
6- Title On and change the title to By Crossing Region
1-
Enter State in the shared axis from Border
Crossing table.
2-
Enter Crossing PM, MoM% and YoY% into the
Tooltips.
3-
Data colors Conditional formatting
a.
Format by color
b.
Based on Crossing PM
c.
Turn on Diverging.
d.
Minimum #07AEF6,
e.
Center Middle Value #EBF705,
f.
Maximum Highest Value #5708F6
4-
Format Map controls Turn off Auto Zoom.
5-
Expand Map Style Theme Gray Scale
6- Title On and change the title to By Crossing by State
1-
Take a screenshot of the Conditional format bar
and save.
2-
Insert tab and Pictures to import the legend.
3-
General
X- Position 1038, Y Position 653, Width 127, Height 14
4-
Insert Text Box- General, X- Position 1126, Y
Position 66, Width 138, Height 29
5- Turn off Background.
Copying and pasting formatted values
https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting